Design and Implementation of a Temporal Extension of SQL
نویسندگان
چکیده
We present a valid-time extension of SQL and investigate its efficient implementation on an Object-Relational database system. We propose an approach where temporal queries are expressed using a point-based time model, which only requires minimal extensions to SQL:1999. Our prototype system called TENORS (for Temporal ENhanced Object-Relational System) maps the external point-based temporal queries and data model into equivalent internal representations based on time intervals. We describe the mapping of queries from external views to internal relations, and the temporal clustering and indexing methods used to support these queries on DB2.
منابع مشابه
SQL Extension for Interval Data
IXSQL, an extension to SQL, is proposed for the management of interval data. IXSQL is syntactically and semantically upwards consistent with SQL2. Its specification has been based both on theoretical results and actual user requirements for the management of temporal data, a special case of interval data. Design decisions and implementation issues are also discussed.
متن کاملV.4: Sql/tp|a Temporal Extension of Sql
We use constraint technology as a basis for SQL/TP, a sound temporal extension of SQL. In contract to most of the earlier proposals, SQL/TP has clean syntax that is consistent with standard SQL, and unambiguous semantics that is rooted in the theory of constraint databases. We also deene a meaningful way of handling aggregation and duplicates, and provide an eecient implementation path on top o...
متن کاملTERC+: A Temporal Conceptual Model
Much work has been done recently on the design of a temporal extension to SQL-92, called TSQL2. Similar work is being done to add temporality to the forthcoming SLQ3 standard. Still, TSQL2 is based on the relational model, which is hardly adequate for conceptual modeling of any but the simplest applications. This paper presents a temporal conceptual model, called TERC+, that can be used for dev...
متن کاملDeveloping an Oracle-Based Spatio-Temporal Information Management System
In this paper, we present an extension of Oracle, named STOC (SpatioTemporal Object Cartridge), to support spatio-temporal data management in a practical way. The extension is developed as a PL/SQL package and can be integrated into Oracle to offer spatio-temporal data types as well as spatio-temporal operations for various applications. Users are allowed to use standard SQL to access spatio-te...
متن کاملTemporal Extension to ODMG
the past years a number of temporal extensions to the different database models have been proposed. Extensions to the relational model have been following the different SQL standards, while no attempts have been made to extend the OO-databases' standard, defined by ODMG. In this paper we present a temporal extension to the ODMG standard, as this has been specified in the TOOBIS project. A Tempo...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2003